Setup

Some notes: Where I thought the data was too jittery, I included a trendline that uses a rolling average and a trendline that shows each individual years of data.

Education : Bachelor Degree Attainment ages 25-64

Ranking

Trendline by ethnicity

It’s a bit tough to break down the data by race and include peer city information on the same graph, since that ends up with 12 lines to fit on the page. The third graph I included here tries to do that. The solid line represents Louisville, the dashed line represents our peer average, and the shaded area represents the 25th and 75th percentiles of our peers. The Bachelor degree version is very messy since the lines for black and hispanic are overlapping so much.

Map

Change

This will be a change graph for bachelor degree attainment by poverty status, though I’m still waiting on Nate to send me his code. I included some other graphs in the meantime.

Note the axes for these are different. Sorry about that.

Assoc Ranking

Assoc Trendline

Young adult degrees

Education pipeline

Still waiting on private school data

Jobs: median earnings

Ranking

Trendline by race

Map

## change: high wage jobs

Earnings gap

Jobs by zip code

I removed some zip codes with very low population to avod skewing the numbers. I also removed downtown because it is so diffferent from everywhere else in the county: if it is included, the rest of the map is white.

Businesses per resident

Jobs per resident

Payroll per resident

Payroll per worker

Unemployment trendline by race

The survey size is too small to include Hispanic residents. I can get ahold of 3- or 5- year estimates, but it will take me a while.

Working poverty

Income inequality

Health: health outcomes index

Ranking

Trendline by race

Map of life expectancy

Change; % of children in poverty

Other:

Health insurance by race

Health insurance by income quartiles (demonstrate impact of expanded Medicaid)

QOP

Ranking: homeownership

Trendline: homeownership by race

Map: homeownership or burdened households

change: home values by areas

Other

% of MSA in core county

Housing stock $ by race

Segregation = % race by % area

Brain drain migration figures

Disconnected youth figures